<DatabaseSchema Name="AdventureWorks">
	<Tables>
		<Table Schema="dbo" Name="AWBuildVersion">
			<TableColumn Name="SystemInformationID" Type="System.Byte" Description="Primary key for AWBuildVersion records."/>
			<TableColumn Name="Database Version" Type="System.String" Description="Version number of the database in 9.yy.mm.dd.00 format."/>
			<TableColumn Name="VersionDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="dbo" Name="DatabaseLog">
			<TableColumn Name="DatabaseLogID" Type="System.Int32" Description="Primary key for DatabaseLog records."/>
			<TableColumn Name="PostTime" Type="System.DateTime" Description="The date and time the DDL change occurred."/>
			<TableColumn Name="DatabaseUser" Type="System.String" Description="The user who implemented the DDL change."/>
			<TableColumn Name="Event" Type="System.String" Description="The type of DDL statement that was executed."/>
			<TableColumn Name="Schema" Type="System.String" Description="The schema to which the changed object belongs."/>
			<TableColumn Name="Object" Type="System.String" Description="The object that was changed by the DDL statment."/>
			<TableColumn Name="TSQL" Type="System.String" Description="The exact Transact-SQL statement that was executed."/>
			<TableColumn Name="XmlEvent" Type="System.String" Description="The raw XML data generated by database trigger."/>
		</Table>
		<Table Schema="dbo" Name="ErrorLog">
			<TableColumn Name="ErrorLogID" Type="System.Int32" Description="Primary key for ErrorLog records."/>
			<TableColumn Name="ErrorTime" Type="System.DateTime" Description="The date and time at which the error occurred."/>
			<TableColumn Name="UserName" Type="System.String" Description="The user who executed the batch in which the error occurred."/>
			<TableColumn Name="ErrorNumber" Type="System.Int32" Description="The error number of the error that occurred."/>
			<TableColumn Name="ErrorSeverity" Type="System.Int32" Description="The severity of the error that occurred."/>
			<TableColumn Name="ErrorState" Type="System.Int32" Description="The state number of the error that occurred."/>
			<TableColumn Name="ErrorProcedure" Type="System.String" Description="The name of the stored procedure or trigger where the error occurred."/>
			<TableColumn Name="ErrorLine" Type="System.Int32" Description="The line number at which the error occurred."/>
			<TableColumn Name="ErrorMessage" Type="System.String" Description="The message text of the error that occurred."/>
		</Table>
		<Table Schema="HumanResources" Name="Department">
			<TableColumn Name="DepartmentID" Type="System.Int16" Description="Primary key for Department records."/>
			<TableColumn Name="Name" Type="System.String" Description="Name of the department."/>
			<TableColumn Name="GroupName" Type="System.String" Description="Name of the group to which the department belongs."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="HumanResources" Name="Employee">
			<TableColumn Name="EmployeeID" Type="System.Int32" Description="Primary key for Employee records."/>
			<TableColumn Name="NationalIDNumber" Type="System.String" Description="Unique national identification number such as a social security number."/>
			<TableColumn Name="ContactID" Type="System.Int32" Description="Identifies the employee in the Contact table. Foreign key to Contact.ContactID."/>
			<TableColumn Name="LoginID" Type="System.String" Description="Network login."/>
			<TableColumn Name="ManagerID" Type="System.Int32" Description="Manager to whom the employee is assigned. Foreign Key to Employee.M"/>
			<TableColumn Name="Title" Type="System.String" Description="Work title such as Buyer or Sales Representative."/>
			<TableColumn Name="BirthDate" Type="System.DateTime" Description="Date of birth."/>
			<TableColumn Name="MaritalStatus" Type="System.String" Description="M = Married, S = Single"/>
			<TableColumn Name="Gender" Type="System.String" Description="M = Male, F = Female"/>
			<TableColumn Name="HireDate" Type="System.DateTime" Description="Employee hired on this date."/>
			<TableColumn Name="SalariedFlag" Type="System.Boolean" Description="Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining."/>
			<TableColumn Name="VacationHours" Type="System.Int16" Description="Number of available vacation hours."/>
			<TableColumn Name="SickLeaveHours" Type="System.Int16" Description="Number of available sick leave hours."/>
			<TableColumn Name="CurrentFlag" Type="System.Boolean" Description="0 = Inactive, 1 = Active"/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="HumanResources" Name="EmployeeAddress">
			<TableColumn Name="EmployeeID" Type="System.Int32" Description="Primary key. Foreign key to Employee.EmployeeID."/>
			<TableColumn Name="AddressID" Type="System.Int32" Description="Primary key. Foreign key to Address.AddressID."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="HumanResources" Name="EmployeeDepartmentHistory">
			<TableColumn Name="EmployeeID" Type="System.Int32" Description="Employee identification number. Foreign key to Employee.EmployeeID."/>
			<TableColumn Name="DepartmentID" Type="System.Int16" Description="Department in which the employee worked including currently. Foreign key to Department.DepartmentID."/>
			<TableColumn Name="ShiftID" Type="System.Byte" Description="Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID."/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="Date the employee started work in the department."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="Date the employee left the department. NULL = Current department."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="HumanResources" Name="EmployeePayHistory">
			<TableColumn Name="EmployeeID" Type="System.Int32" Description="Employee identification number. Foreign key to Employee.EmployeeID."/>
			<TableColumn Name="RateChangeDate" Type="System.DateTime" Description="Date the change in pay is effective"/>
			<TableColumn Name="Rate" Type="System.Decimal" Description="Salary hourly rate."/>
			<TableColumn Name="PayFrequency" Type="System.Byte" Description="1 = Salary received monthly, 2 = Salary received biweekly"/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="HumanResources" Name="JobCandidate">
			<TableColumn Name="JobCandidateID" Type="System.Int32" Description="Primary key for JobCandidate records."/>
			<TableColumn Name="EmployeeID" Type="System.Int32" Description="Employee identification number if applicant was hired. Foreign key to Employee.EmployeeID."/>
			<TableColumn Name="Resume" Type="System.String" Description="Résumé in XML format."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="HumanResources" Name="Shift">
			<TableColumn Name="ShiftID" Type="System.Byte" Description="Primary key for Shift records."/>
			<TableColumn Name="Name" Type="System.String" Description="Shift description."/>
			<TableColumn Name="StartTime" Type="System.DateTime" Description="Shift start time."/>
			<TableColumn Name="EndTime" Type="System.DateTime" Description="Shift end time."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Person" Name="Address">
			<TableColumn Name="AddressID" Type="System.Int32" Description="Primary key for Address records."/>
			<TableColumn Name="AddressLine1" Type="System.String" Description="First street address line."/>
			<TableColumn Name="AddressLine2" Type="System.String" Description="Second street address line."/>
			<TableColumn Name="City" Type="System.String" Description="Name of the city."/>
			<TableColumn Name="StateProvinceID" Type="System.Int32" Description="Unique identification number for the state or province. Foreign key to StateProvince table."/>
			<TableColumn Name="PostalCode" Type="System.String" Description="Postal code for the street address."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Person" Name="AddressType">
			<TableColumn Name="AddressTypeID" Type="System.Int32" Description="Primary key for AddressType records."/>
			<TableColumn Name="Name" Type="System.String" Description="Address type description. For example, Billing, Home, or Shipping."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Person" Name="Contact">
			<TableColumn Name="ContactID" Type="System.Int32" Description="Primary key for Contact records."/>
			<TableColumn Name="NameStyle" Type="System.Boolean" Description="0 = The data in FirstName and LastName are stored in western style (first name, last name) order.  1 = Eastern style (last name, first name) order."/>
			<TableColumn Name="Title" Type="System.String" Description="A courtesy title. For example, Mr. or Ms."/>
			<TableColumn Name="FirstName" Type="System.String" Description="First name of the person."/>
			<TableColumn Name="MiddleName" Type="System.String" Description="Middle name or middle initial of the person."/>
			<TableColumn Name="LastName" Type="System.String" Description="Last name of the person."/>
			<TableColumn Name="Suffix" Type="System.String" Description="Surname suffix. For example, Sr. or Jr."/>
			<TableColumn Name="EmailAddress" Type="System.String" Description="E-mail address for the person."/>
			<TableColumn Name="EmailPromotion" Type="System.Int32" Description="0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners. "/>
			<TableColumn Name="Phone" Type="System.String" Description="Phone number associated with the person."/>
			<TableColumn Name="PasswordHash" Type="System.String" Description="Password for the e-mail account."/>
			<TableColumn Name="PasswordSalt" Type="System.String" Description="Random value concatenated with the password string before the password is hashed."/>
			<TableColumn Name="AdditionalContactInfo" Type="System.String" Description="Additional contact information about the person stored in xml format. "/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Person" Name="ContactType">
			<TableColumn Name="ContactTypeID" Type="System.Int32" Description="Primary key for ContactType records."/>
			<TableColumn Name="Name" Type="System.String" Description="Contact type description."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Person" Name="CountryRegion">
			<TableColumn Name="CountryRegionCode" Type="System.String" Description="ISO standard code for countries and regions."/>
			<TableColumn Name="Name" Type="System.String" Description="Country or region name."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Person" Name="StateProvince">
			<TableColumn Name="StateProvinceID" Type="System.Int32" Description="Primary key for StateProvince records."/>
			<TableColumn Name="StateProvinceCode" Type="System.String" Description="ISO standard state or province code."/>
			<TableColumn Name="CountryRegionCode" Type="System.String" Description="ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. "/>
			<TableColumn Name="IsOnlyStateProvinceFlag" Type="System.Boolean" Description="0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode."/>
			<TableColumn Name="Name" Type="System.String" Description="State or province description."/>
			<TableColumn Name="TerritoryID" Type="System.Int32" Description="ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="BillOfMaterials">
			<TableColumn Name="BillOfMaterialsID" Type="System.Int32" Description="Primary key for BillOfMaterials records."/>
			<TableColumn Name="ProductAssemblyID" Type="System.Int32" Description="Parent product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="ComponentID" Type="System.Int32" Description="Component identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="Date the component started being used in the assembly item."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="Date the component stopped being used in the assembly item."/>
			<TableColumn Name="UnitMeasureCode" Type="System.String" Description="Standard code identifying the unit of measure for the quantity."/>
			<TableColumn Name="BOMLevel" Type="System.Int16" Description="Indicates the depth the component is from its parent (AssemblyID)."/>
			<TableColumn Name="PerAssemblyQty" Type="System.Decimal" Description="Quantity of the component needed to create the assembly."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="Culture">
			<TableColumn Name="CultureID" Type="System.String" Description="Primary key for Culture records."/>
			<TableColumn Name="Name" Type="System.String" Description="Culture description."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="Document">
			<TableColumn Name="DocumentID" Type="System.Int32" Description="Primary key for Document records."/>
			<TableColumn Name="Title" Type="System.String" Description="Title of the document."/>
			<TableColumn Name="FileName" Type="System.String" Description="Directory path and file name of the document"/>
			<TableColumn Name="FileExtension" Type="System.String" Description="File extension indicating the document type. For example, .doc or .txt."/>
			<TableColumn Name="Revision" Type="System.String" Description="Revision number of the document. "/>
			<TableColumn Name="ChangeNumber" Type="System.Int32" Description="Engineering change approval number."/>
			<TableColumn Name="Status" Type="System.Byte" Description="1 = Pending approval, 2 = Approved, 3 = Obsolete"/>
			<TableColumn Name="DocumentSummary" Type="System.String" Description="Document abstract."/>
			<TableColumn Name="Document" Type="Unknown" Description="Complete document."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="Illustration">
			<TableColumn Name="IllustrationID" Type="System.Int32" Description="Primary key for Illustration records."/>
			<TableColumn Name="Diagram" Type="System.String" Description="Illustrations used in manufacturing instructions. Stored as XML."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="Location">
			<TableColumn Name="LocationID" Type="System.Int16" Description="Primary key for Location records."/>
			<TableColumn Name="Name" Type="System.String" Description="Location description."/>
			<TableColumn Name="CostRate" Type="System.Decimal" Description="Standard hourly cost of the manufacturing location."/>
			<TableColumn Name="Availability" Type="System.Decimal" Description="Work capacity (in hours) of the manufacturing location."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="Product">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Primary key for Product records."/>
			<TableColumn Name="Name" Type="System.String" Description="Name of the product."/>
			<TableColumn Name="ProductNumber" Type="System.String" Description="Unique product identification number."/>
			<TableColumn Name="MakeFlag" Type="System.Boolean" Description="0 = Product is purchased, 1 = Product is manufactured in-house."/>
			<TableColumn Name="FinishedGoodsFlag" Type="System.Boolean" Description="0 = Product is not a salable item. 1 = Product is salable."/>
			<TableColumn Name="Color" Type="System.String" Description="Product color."/>
			<TableColumn Name="SafetyStockLevel" Type="System.Int16" Description="Minimum inventory quantity. "/>
			<TableColumn Name="ReorderPoint" Type="System.Int16" Description="Inventory level that triggers a purchase order or work order. "/>
			<TableColumn Name="StandardCost" Type="System.Decimal" Description="Standard cost of the product."/>
			<TableColumn Name="ListPrice" Type="System.Decimal" Description="Selling price."/>
			<TableColumn Name="Size" Type="System.String" Description="Product size."/>
			<TableColumn Name="SizeUnitMeasureCode" Type="System.String" Description="Unit of measure for Size column."/>
			<TableColumn Name="WeightUnitMeasureCode" Type="System.String" Description="Unit of measure for Weight column."/>
			<TableColumn Name="Weight" Type="System.Decimal" Description="Product weight."/>
			<TableColumn Name="DaysToManufacture" Type="System.Int32" Description="Number of days required to manufacture the product."/>
			<TableColumn Name="ProductLine" Type="System.String" Description="R = Road, M = Mountain, T = Touring, S = Standard"/>
			<TableColumn Name="Class" Type="System.String" Description="H = High, M = Medium, L = Low"/>
			<TableColumn Name="Style" Type="System.String" Description="W = Womens, M = Mens, U = Universal"/>
			<TableColumn Name="ProductSubcategoryID" Type="System.Int32" Description="Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. "/>
			<TableColumn Name="ProductModelID" Type="System.Int32" Description="Product is a member of this product model. Foreign key to ProductModel.ProductModelID."/>
			<TableColumn Name="SellStartDate" Type="System.DateTime" Description="Date the product was available for sale."/>
			<TableColumn Name="SellEndDate" Type="System.DateTime" Description="Date the product was no longer available for sale."/>
			<TableColumn Name="DiscontinuedDate" Type="System.DateTime" Description="Date the product was discontinued."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductCategory">
			<TableColumn Name="ProductCategoryID" Type="System.Int32" Description="Primary key for ProductCategory records."/>
			<TableColumn Name="Name" Type="System.String" Description="Category description."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductCostHistory">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID"/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="Product cost start date."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="Product cost end date."/>
			<TableColumn Name="StandardCost" Type="System.Decimal" Description="Standard cost of the product."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductDescription">
			<TableColumn Name="ProductDescriptionID" Type="System.Int32" Description="Primary key for ProductDescription records."/>
			<TableColumn Name="Description" Type="System.String" Description="Description of the product."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductDocument">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="DocumentID" Type="System.Int32" Description="Document identification number. Foreign key to Document.DocumentID."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductInventory">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="LocationID" Type="System.Int16" Description="Inventory location identification number. Foreign key to Location.LocationID. "/>
			<TableColumn Name="Shelf" Type="System.String" Description="Storage compartment within an inventory location."/>
			<TableColumn Name="Bin" Type="System.Byte" Description="Storage container on a shelf in an inventory location."/>
			<TableColumn Name="Quantity" Type="System.Int16" Description="Quantity of products in the inventory location."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductListPriceHistory">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID"/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="List price start date."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="List price end date"/>
			<TableColumn Name="ListPrice" Type="System.Decimal" Description="Product list price."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductModel">
			<TableColumn Name="ProductModelID" Type="System.Int32" Description="Primary key for ProductModel records."/>
			<TableColumn Name="Name" Type="System.String" Description="Product model description."/>
			<TableColumn Name="CatalogDescription" Type="System.String" Description="Detailed product catalog information in xml format."/>
			<TableColumn Name="Instructions" Type="System.String" Description="Manufacturing instructions in xml format."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductModelIllustration">
			<TableColumn Name="ProductModelID" Type="System.Int32" Description="Primary key. Foreign key to ProductModel.ProductModelID."/>
			<TableColumn Name="IllustrationID" Type="System.Int32" Description="Primary key. Foreign key to Illustration.IllustrationID."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductModelProductDescriptionCulture">
			<TableColumn Name="ProductModelID" Type="System.Int32" Description="Primary key. Foreign key to ProductModel.ProductModelID."/>
			<TableColumn Name="ProductDescriptionID" Type="System.Int32" Description="Primary key. Foreign key to ProductDescription.ProductDescriptionID."/>
			<TableColumn Name="CultureID" Type="System.String" Description="Culture identification number. Foreign key to Culture.CultureID."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductPhoto">
			<TableColumn Name="ProductPhotoID" Type="System.Int32" Description="Primary key for ProductPhoto records."/>
			<TableColumn Name="ThumbNailPhoto" Type="Unknown" Description="Small image of the product."/>
			<TableColumn Name="ThumbnailPhotoFileName" Type="System.String" Description="Small image file name."/>
			<TableColumn Name="LargePhoto" Type="Unknown" Description="Large image of the product."/>
			<TableColumn Name="LargePhotoFileName" Type="System.String" Description="Large image file name."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductProductPhoto">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="ProductPhotoID" Type="System.Int32" Description="Product photo identification number. Foreign key to ProductPhoto.ProductPhotoID."/>
			<TableColumn Name="Primary" Type="System.Boolean" Description="0 = Photo is not the principal image. 1 = Photo is the principal image."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductReview">
			<TableColumn Name="ProductReviewID" Type="System.Int32" Description="Primary key for ProductReview records."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="ReviewerName" Type="System.String" Description="Name of the reviewer."/>
			<TableColumn Name="ReviewDate" Type="System.DateTime" Description="Date review was submitted."/>
			<TableColumn Name="EmailAddress" Type="System.String" Description="Reviewer's e-mail address."/>
			<TableColumn Name="Rating" Type="System.Int32" Description="Product rating given by the reviewer. Scale is 1 to 5 with 5 as the highest rating."/>
			<TableColumn Name="Comments" Type="System.String" Description="Reviewer's comments"/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ProductSubcategory">
			<TableColumn Name="ProductSubcategoryID" Type="System.Int32" Description="Primary key for ProductSubcategory records."/>
			<TableColumn Name="ProductCategoryID" Type="System.Int32" Description="Product category identification number. Foreign key to ProductCategory.ProductCategoryID."/>
			<TableColumn Name="Name" Type="System.String" Description="Subcategory description."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="ScrapReason">
			<TableColumn Name="ScrapReasonID" Type="System.Int16" Description="Primary key for ScrapReason records."/>
			<TableColumn Name="Name" Type="System.String" Description="Failure description."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="TransactionHistory">
			<TableColumn Name="TransactionID" Type="System.Int32" Description="Primary key for TransactionHistory records."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="ReferenceOrderID" Type="System.Int32" Description="Purchase order, sales order, or work order identification number."/>
			<TableColumn Name="ReferenceOrderLineID" Type="System.Int32" Description="Line number associated with the purchase order, sales order, or work order."/>
			<TableColumn Name="TransactionDate" Type="System.DateTime" Description="Date and time of the transaction."/>
			<TableColumn Name="TransactionType" Type="System.String" Description="W = WorkOrder, S = SalesOrder, P = PurchaseOrder"/>
			<TableColumn Name="Quantity" Type="System.Int32" Description="Product quantity."/>
			<TableColumn Name="ActualCost" Type="System.Decimal" Description="Product cost."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="TransactionHistoryArchive">
			<TableColumn Name="TransactionID" Type="System.Int32" Description="Primary key for TransactionHistoryArchive records."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="ReferenceOrderID" Type="System.Int32" Description="Purchase order, sales order, or work order identification number."/>
			<TableColumn Name="ReferenceOrderLineID" Type="System.Int32" Description="Line number associated with the purchase order, sales order, or work order."/>
			<TableColumn Name="TransactionDate" Type="System.DateTime" Description="Date and time of the transaction."/>
			<TableColumn Name="TransactionType" Type="System.String" Description="W = Work Order, S = Sales Order, P = Purchase Order"/>
			<TableColumn Name="Quantity" Type="System.Int32" Description="Product quantity."/>
			<TableColumn Name="ActualCost" Type="System.Decimal" Description="Product cost."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="UnitMeasure">
			<TableColumn Name="UnitMeasureCode" Type="System.String" Description="Primary key."/>
			<TableColumn Name="Name" Type="System.String" Description="Unit of measure description."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="WorkOrder">
			<TableColumn Name="WorkOrderID" Type="System.Int32" Description="Primary key for WorkOrder records."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="OrderQty" Type="System.Int32" Description="Product quantity to build."/>
			<TableColumn Name="StockedQty" Type="System.Int32" Description="Quantity built and put in inventory."/>
			<TableColumn Name="ScrappedQty" Type="System.Int16" Description="Quantity that failed inspection."/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="Work order start date."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="Work order end date."/>
			<TableColumn Name="DueDate" Type="System.DateTime" Description="Work order due date."/>
			<TableColumn Name="ScrapReasonID" Type="System.Int16" Description="Reason for inspection failure."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Production" Name="WorkOrderRouting">
			<TableColumn Name="WorkOrderID" Type="System.Int32" Description="Primary key. Foreign key to WorkOrder.WorkOrderID."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Primary key. Foreign key to Product.ProductID."/>
			<TableColumn Name="OperationSequence" Type="System.Int16" Description="Primary key. Indicates the manufacturing process sequence."/>
			<TableColumn Name="LocationID" Type="System.Int16" Description="Manufacturing location where the part is processed. Foreign key to Location.LocationID."/>
			<TableColumn Name="ScheduledStartDate" Type="System.DateTime" Description="Planned manufacturing start date."/>
			<TableColumn Name="ScheduledEndDate" Type="System.DateTime" Description="Planned manufacturing end date."/>
			<TableColumn Name="ActualStartDate" Type="System.DateTime" Description="Actual start date."/>
			<TableColumn Name="ActualEndDate" Type="System.DateTime" Description="Actual end date."/>
			<TableColumn Name="ActualResourceHrs" Type="System.Decimal" Description="Number of manufacturing hours used."/>
			<TableColumn Name="PlannedCost" Type="System.Decimal" Description="Estimated manufacturing cost."/>
			<TableColumn Name="ActualCost" Type="System.Decimal" Description="Actual manufacturing cost."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="ProductVendor">
			<TableColumn Name="ProductID" Type="System.Int32" Description="Primary key. Foreign key to Product.ProductID."/>
			<TableColumn Name="VendorID" Type="System.Int32" Description="Primary key. Foreign key to Vendor.VendorID."/>
			<TableColumn Name="AverageLeadTime" Type="System.Int32" Description="The average span of time (in days) between placing an order with the vendor and receiving the purchased product."/>
			<TableColumn Name="StandardPrice" Type="System.Decimal" Description="The vendor's usual selling price."/>
			<TableColumn Name="LastReceiptCost" Type="System.Decimal" Description="The selling price when last purchased."/>
			<TableColumn Name="LastReceiptDate" Type="System.DateTime" Description="Date the product was last received by the vendor."/>
			<TableColumn Name="MinOrderQty" Type="System.Int32" Description="The maximum quantity that should be ordered."/>
			<TableColumn Name="MaxOrderQty" Type="System.Int32" Description="The minimum quantity that should be ordered."/>
			<TableColumn Name="OnOrderQty" Type="System.Int32" Description="The quantity currently on order."/>
			<TableColumn Name="UnitMeasureCode" Type="System.String" Description="The product's unit of measure."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="PurchaseOrderDetail">
			<TableColumn Name="PurchaseOrderID" Type="System.Int32" Description="Primary key. Foreign key to PurchaseOrderHeader.PurchaseOrderID."/>
			<TableColumn Name="PurchaseOrderDetailID" Type="System.Int32" Description="Primary key. One line number per purchased product."/>
			<TableColumn Name="DueDate" Type="System.DateTime" Description="Date the product is expected to be received."/>
			<TableColumn Name="OrderQty" Type="System.Int16" Description="Quantity ordered."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="UnitPrice" Type="System.Decimal" Description="Vendor's selling price of a single product."/>
			<TableColumn Name="LineTotal" Type="System.Decimal" Description="Per product subtotal. Computed as OrderQty * UnitPrice."/>
			<TableColumn Name="ReceivedQty" Type="System.Decimal" Description="Quantity actually received from the vendor."/>
			<TableColumn Name="RejectedQty" Type="System.Decimal" Description="Quantity rejected during inspection."/>
			<TableColumn Name="StockedQty" Type="System.Decimal" Description="Quantity accepted into inventory. Computed as ReceivedQty - RejectedQty."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="PurchaseOrderHeader">
			<TableColumn Name="PurchaseOrderID" Type="System.Int32" Description="Primary key."/>
			<TableColumn Name="RevisionNumber" Type="System.Byte" Description="Incremental number to track changes to the purchase order over time."/>
			<TableColumn Name="Status" Type="System.Byte" Description="Order current status. 1 = Pending; 2 = Approved; 3 = Rejected; 4 = Complete"/>
			<TableColumn Name="EmployeeID" Type="System.Int32" Description="Employee who created the purchase order. Foreign key to Employee.EmployeeID."/>
			<TableColumn Name="VendorID" Type="System.Int32" Description="Vendor with whom the purchase order is placed. Foreign key to Vendor.VendorID."/>
			<TableColumn Name="ShipMethodID" Type="System.Int32" Description="Shipping method. Foreign key to ShipMethod.ShipMethodID."/>
			<TableColumn Name="OrderDate" Type="System.DateTime" Description="Purchase order creation date."/>
			<TableColumn Name="ShipDate" Type="System.DateTime" Description="Estimated shipment date from the vendor."/>
			<TableColumn Name="SubTotal" Type="System.Decimal" Description="Purchase order subtotal. Computed as SUM(PurchaseOrderDetail.LineTotal)for the appropriate PurchaseOrderID."/>
			<TableColumn Name="TaxAmt" Type="System.Decimal" Description="Tax amount."/>
			<TableColumn Name="Freight" Type="System.Decimal" Description="Shipping cost."/>
			<TableColumn Name="TotalDue" Type="System.Decimal" Description="Total due to vendor. Computed as Subtotal + TaxAmt + Freight."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="ShipMethod">
			<TableColumn Name="ShipMethodID" Type="System.Int32" Description="Primary key for ShipMethod records."/>
			<TableColumn Name="Name" Type="System.String" Description="Shipping company name."/>
			<TableColumn Name="ShipBase" Type="System.Decimal" Description="Minimum shipping charge."/>
			<TableColumn Name="ShipRate" Type="System.Decimal" Description="Shipping charge per pound."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="Vendor">
			<TableColumn Name="VendorID" Type="System.Int32" Description="Primary key for Vendor records."/>
			<TableColumn Name="AccountNumber" Type="System.String" Description="Vendor account (identification) number."/>
			<TableColumn Name="Name" Type="System.String" Description="Company name."/>
			<TableColumn Name="CreditRating" Type="System.Byte" Description="1 = Superior, 2 = Excellent, 3 = Above average, 4 = Average, 5 = Below average"/>
			<TableColumn Name="PreferredVendorStatus" Type="System.Boolean" Description="0 = Do not use if another vendor is available. 1 = Preferred over other vendors supplying the same product."/>
			<TableColumn Name="ActiveFlag" Type="System.Boolean" Description="0 = Vendor no longer used. 1 = Vendor is actively used."/>
			<TableColumn Name="PurchasingWebServiceURL" Type="System.String" Description="Vendor URL."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="VendorAddress">
			<TableColumn Name="VendorID" Type="System.Int32" Description="Primary key. Foreign key to Vendor.VendorID."/>
			<TableColumn Name="AddressID" Type="System.Int32" Description="Primary key. Foreign key to Address.AddressID."/>
			<TableColumn Name="AddressTypeID" Type="System.Int32" Description="Address type. Foreign key to AddressType.AddressTypeID."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Purchasing" Name="VendorContact">
			<TableColumn Name="VendorID" Type="System.Int32" Description="Primary key."/>
			<TableColumn Name="ContactID" Type="System.Int32" Description="Contact (Vendor employee) identification number. Foreign key to Contact.ContactID."/>
			<TableColumn Name="ContactTypeID" Type="System.Int32" Description="Contact type such as sales manager, or sales agent."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="ContactCreditCard">
			<TableColumn Name="ContactID" Type="System.Int32" Description="Customer identification number. Foreign key to Contact.ContactID."/>
			<TableColumn Name="CreditCardID" Type="System.Int32" Description="Credit card identification number. Foreign key to CreditCard.CreditCardID."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="CountryRegionCurrency">
			<TableColumn Name="CountryRegionCode" Type="System.String" Description="ISO code for countries and regions. Foreign key to CountryRegion.CountryRegionCode."/>
			<TableColumn Name="CurrencyCode" Type="System.String" Description="ISO standard currency code. Foreign key to Currency.CurrencyCode."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="CreditCard">
			<TableColumn Name="CreditCardID" Type="System.Int32" Description="Primary key for CreditCard records."/>
			<TableColumn Name="CardType" Type="System.String" Description="Credit card name."/>
			<TableColumn Name="CardNumber" Type="System.String" Description="Credit card number."/>
			<TableColumn Name="ExpMonth" Type="System.Byte" Description="Credit card expiration month."/>
			<TableColumn Name="ExpYear" Type="System.Int16" Description="Credit card expiration year."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="Currency">
			<TableColumn Name="CurrencyCode" Type="System.String" Description="The ISO code for the Currency."/>
			<TableColumn Name="Name" Type="System.String" Description="Currency name."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="CurrencyRate">
			<TableColumn Name="CurrencyRateID" Type="System.Int32" Description="Primary key for CurrencyRate records."/>
			<TableColumn Name="CurrencyRateDate" Type="System.DateTime" Description="Date and time the exchange rate was obtained."/>
			<TableColumn Name="FromCurrencyCode" Type="System.String" Description="Exchange rate was converted from this currency code."/>
			<TableColumn Name="ToCurrencyCode" Type="System.String" Description="Exchange rate was converted to this currency code."/>
			<TableColumn Name="AverageRate" Type="System.Decimal" Description="Average exchange rate for the day."/>
			<TableColumn Name="EndOfDayRate" Type="System.Decimal" Description="Final exchange rate for the day."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="Customer">
			<TableColumn Name="CustomerID" Type="System.Int32" Description="Primary key for Customer records."/>
			<TableColumn Name="TerritoryID" Type="System.Int32" Description="ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID."/>
			<TableColumn Name="AccountNumber" Type="System.String" Description="Unique number identifying the customer assigned by the accounting system."/>
			<TableColumn Name="CustomerType" Type="System.String" Description="Customer type: I = Individual, S = Store"/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="CustomerAddress">
			<TableColumn Name="CustomerID" Type="System.Int32" Description="Primary key. Foreign key to Customer.CustomerID."/>
			<TableColumn Name="AddressID" Type="System.Int32" Description="Primary key. Foreign key to Address.AddressID."/>
			<TableColumn Name="AddressTypeID" Type="System.Int32" Description="Address type. Foreign key to AddressType.AddressTypeID."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="Individual">
			<TableColumn Name="CustomerID" Type="System.Int32" Description="Unique customer identification number. Foreign key to Customer.CustomerID."/>
			<TableColumn Name="ContactID" Type="System.Int32" Description="Identifies the customer in the Contact table. Foreign key to Contact.ContactID."/>
			<TableColumn Name="Demographics" Type="System.String" Description="Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesOrderDetail">
			<TableColumn Name="SalesOrderID" Type="System.Int32" Description="Primary key. Foreign key to SalesOrderHeader.SalesOrderID."/>
			<TableColumn Name="SalesOrderDetailID" Type="System.Int32" Description="Primary key. One incremental unique number per product sold."/>
			<TableColumn Name="CarrierTrackingNumber" Type="System.String" Description="Shipment tracking number supplied by the shipper."/>
			<TableColumn Name="OrderQty" Type="System.Int16" Description="Quantity ordered per product."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product sold to customer. Foreign key to Product.ProductID."/>
			<TableColumn Name="SpecialOfferID" Type="System.Int32" Description="Promotional code. Foreign key to SpecialOffer.SpecialOfferID."/>
			<TableColumn Name="UnitPrice" Type="System.Decimal" Description="Selling price of a single product."/>
			<TableColumn Name="UnitPriceDiscount" Type="System.Decimal" Description="Discount amount."/>
			<TableColumn Name="LineTotal" Type="System.Decimal" Description="Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesOrderHeader">
			<TableColumn Name="SalesOrderID" Type="System.Int32" Description="Primary key."/>
			<TableColumn Name="RevisionNumber" Type="System.Byte" Description="Incremental number to track changes to the sales order over time."/>
			<TableColumn Name="OrderDate" Type="System.DateTime" Description="Dates the sales order was created."/>
			<TableColumn Name="DueDate" Type="System.DateTime" Description="Date the order is due to the customer."/>
			<TableColumn Name="ShipDate" Type="System.DateTime" Description="Date the order was shipped to the customer."/>
			<TableColumn Name="Status" Type="System.Byte" Description="Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled"/>
			<TableColumn Name="OnlineOrderFlag" Type="System.Boolean" Description="0 = Order placed by sales person. 1 = Order placed online by customer."/>
			<TableColumn Name="SalesOrderNumber" Type="System.String" Description="Unique sales order identification number."/>
			<TableColumn Name="PurchaseOrderNumber" Type="System.String" Description="Customer purchase order number reference. "/>
			<TableColumn Name="AccountNumber" Type="System.String" Description="Financial accounting number reference."/>
			<TableColumn Name="CustomerID" Type="System.Int32" Description="Customer identification number. Foreign key to Customer.CustomerID."/>
			<TableColumn Name="ContactID" Type="System.Int32" Description="Customer contact identification number. Foreign key to Contact.ContactID."/>
			<TableColumn Name="SalesPersonID" Type="System.Int32" Description="Sales person who created the sales order. Foreign key to SalesPerson.SalePersonID."/>
			<TableColumn Name="TerritoryID" Type="System.Int32" Description="Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID."/>
			<TableColumn Name="BillToAddressID" Type="System.Int32" Description="Customer billing address. Foreign key to Address.AddressID."/>
			<TableColumn Name="ShipToAddressID" Type="System.Int32" Description="Customer shipping address. Foreign key to Address.AddressID."/>
			<TableColumn Name="ShipMethodID" Type="System.Int32" Description="Shipping method. Foreign key to ShipMethod.ShipMethodID."/>
			<TableColumn Name="CreditCardID" Type="System.Int32" Description="Credit card identification number. Foreign key to CreditCard.CreditCardID."/>
			<TableColumn Name="CreditCardApprovalCode" Type="System.String" Description="Approval code provided by the credit card company."/>
			<TableColumn Name="CurrencyRateID" Type="System.Int32" Description="Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID."/>
			<TableColumn Name="SubTotal" Type="System.Decimal" Description="Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID."/>
			<TableColumn Name="TaxAmt" Type="System.Decimal" Description="Tax amount."/>
			<TableColumn Name="Freight" Type="System.Decimal" Description="Shipping cost."/>
			<TableColumn Name="TotalDue" Type="System.Decimal" Description="Total due from customer. Computed as Subtotal + TaxAmt + Freight."/>
			<TableColumn Name="Comment" Type="System.String" Description="Sales representative comments."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesOrderHeaderSalesReason">
			<TableColumn Name="SalesOrderID" Type="System.Int32" Description="Primary key. Foreign key to SalesOrderHeader.SalesOrderID."/>
			<TableColumn Name="SalesReasonID" Type="System.Int32" Description="Primary key. Foreign key to SalesReason.SalesReasonID."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesPerson">
			<TableColumn Name="SalesPersonID" Type="System.Int32" Description="Primary key for SalesPerson records."/>
			<TableColumn Name="TerritoryID" Type="System.Int32" Description="Territory currently assigned to. Foreign key to SalesTerritory.SalesTerritoryID."/>
			<TableColumn Name="SalesQuota" Type="System.Decimal" Description="Projected yearly sales."/>
			<TableColumn Name="Bonus" Type="System.Decimal" Description="Bonus due if quota is met."/>
			<TableColumn Name="CommissionPct" Type="System.Decimal" Description="Commision percent received per sale."/>
			<TableColumn Name="SalesYTD" Type="System.Decimal" Description="Sales total year to date."/>
			<TableColumn Name="SalesLastYear" Type="System.Decimal" Description="Sales total of previous year."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesPersonQuotaHistory">
			<TableColumn Name="SalesPersonID" Type="System.Int32" Description="Sales person identification number. Foreign key to SalesPerson.SalesPersonID."/>
			<TableColumn Name="QuotaDate" Type="System.DateTime" Description="Sales quota date."/>
			<TableColumn Name="SalesQuota" Type="System.Decimal" Description="Sales quota amount."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesReason">
			<TableColumn Name="SalesReasonID" Type="System.Int32" Description="Primary key for SalesReason records."/>
			<TableColumn Name="Name" Type="System.String" Description="Sales reason description."/>
			<TableColumn Name="ReasonType" Type="System.String" Description="Category the sales reason belongs to."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesTaxRate">
			<TableColumn Name="SalesTaxRateID" Type="System.Int32" Description="Primary key for SalesTaxRate records."/>
			<TableColumn Name="StateProvinceID" Type="System.Int32" Description="State, province, or country/region the sales tax applies to."/>
			<TableColumn Name="TaxType" Type="System.Byte" Description="1 = Tax applied to retail transactions, 2 = Tax applied to wholesale transactions, 3 = Tax applied to all sales (retail and wholesale) transactions."/>
			<TableColumn Name="TaxRate" Type="System.Decimal" Description="Tax rate amount."/>
			<TableColumn Name="Name" Type="System.String" Description="Tax rate description."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesTerritory">
			<TableColumn Name="TerritoryID" Type="System.Int32" Description="Primary key for SalesTerritory records."/>
			<TableColumn Name="Name" Type="System.String" Description="Sales territory description"/>
			<TableColumn Name="CountryRegionCode" Type="System.String" Description="ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. "/>
			<TableColumn Name="Group" Type="System.String" Description="Geographic area to which the sales territory belong."/>
			<TableColumn Name="SalesYTD" Type="System.Decimal" Description="Sales in the territory year to date."/>
			<TableColumn Name="SalesLastYear" Type="System.Decimal" Description="Sales in the territory the previous year."/>
			<TableColumn Name="CostYTD" Type="System.Decimal" Description="Business costs in the territory year to date."/>
			<TableColumn Name="CostLastYear" Type="System.Decimal" Description="Business costs in the territory the previous year."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SalesTerritoryHistory">
			<TableColumn Name="SalesPersonID" Type="System.Int32" Description="Primary key for SalesTerritoryHistory records."/>
			<TableColumn Name="TerritoryID" Type="System.Int32" Description="Territory identification number. Foreign key to SalesTerritory.SalesTerritoryID."/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="Date the sales representive started work in the territory."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="Date the sales representative left work in the territory."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="ShoppingCartItem">
			<TableColumn Name="ShoppingCartItemID" Type="System.Int32" Description="Primary key for ShoppingCartItem records."/>
			<TableColumn Name="ShoppingCartID" Type="System.String" Description="Shopping cart identification number."/>
			<TableColumn Name="Quantity" Type="System.Int32" Description="Product quantity ordered."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product ordered. Foreign key to Product.ProductID."/>
			<TableColumn Name="DateCreated" Type="System.DateTime" Description="Date the time the record was created."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SpecialOffer">
			<TableColumn Name="SpecialOfferID" Type="System.Int32" Description="Primary key for SpecialOffer records."/>
			<TableColumn Name="Description" Type="System.String" Description="Discount description."/>
			<TableColumn Name="DiscountPct" Type="System.Decimal" Description="Discount precentage."/>
			<TableColumn Name="Type" Type="System.String" Description="Discount type category."/>
			<TableColumn Name="Category" Type="System.String" Description="Group the discount applies to such as Reseller or Customer."/>
			<TableColumn Name="StartDate" Type="System.DateTime" Description="Discount start date."/>
			<TableColumn Name="EndDate" Type="System.DateTime" Description="Discount end date."/>
			<TableColumn Name="MinQty" Type="System.Int32" Description="Minimum discount percent allowed."/>
			<TableColumn Name="MaxQty" Type="System.Int32" Description="Maximum discount percent allowed."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="SpecialOfferProduct">
			<TableColumn Name="SpecialOfferID" Type="System.Int32" Description="Primary key for SpecialOfferProduct records."/>
			<TableColumn Name="ProductID" Type="System.Int32" Description="Product identification number. Foreign key to Product.ProductID."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="Store">
			<TableColumn Name="CustomerID" Type="System.Int32" Description="Primary key. Foreign key to Customer.CustomerID."/>
			<TableColumn Name="Name" Type="System.String" Description="Name of the store."/>
			<TableColumn Name="SalesPersonID" Type="System.Int32" Description="ID of the sales person assigned to the customer. Foreign key to SalesPerson.SalesPersonID."/>
			<TableColumn Name="Demographics" Type="System.String" Description="Demographic informationg about the store such as the number of employees, annual sales and store type."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
		<Table Schema="Sales" Name="StoreContact">
			<TableColumn Name="CustomerID" Type="System.Int32" Description="Store identification number. Foreign key to Customer.CustomerID."/>
			<TableColumn Name="ContactID" Type="System.Int32" Description="Contact (store employee) identification number. Foreign key to Contact.ContactID."/>
			<TableColumn Name="ContactTypeID" Type="System.Int32" Description="Contact type such as owner or purchasing agent. Foreign key to ContactType.ContactTypeID."/>
			<TableColumn Name="rowguid" Type="System.Guid" Description="ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample."/>
			<TableColumn Name="ModifiedDate" Type="System.DateTime" Description="Date and time the record was last updated."/>
		</Table>
	</Tables>
	<Relations>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="HumanResources" Table="Employee" Column="ManagerID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Contact" Column="ContactID"/>
			<ForeignKey Schema="HumanResources" Table="Employee" Column="ContactID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="HumanResources" Table="EmployeeAddress" Column="EmployeeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Address" Column="AddressID"/>
			<ForeignKey Schema="HumanResources" Table="EmployeeAddress" Column="AddressID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Department" Column="DepartmentID"/>
			<ForeignKey Schema="HumanResources" Table="EmployeeDepartmentHistory" Column="DepartmentID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="HumanResources" Table="EmployeeDepartmentHistory" Column="EmployeeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Shift" Column="ShiftID"/>
			<ForeignKey Schema="HumanResources" Table="EmployeeDepartmentHistory" Column="ShiftID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="HumanResources" Table="EmployeePayHistory" Column="EmployeeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="HumanResources" Table="JobCandidate" Column="EmployeeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="StateProvince" Column="StateProvinceID"/>
			<ForeignKey Schema="Person" Table="Address" Column="StateProvinceID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="CountryRegion" Column="CountryRegionCode"/>
			<ForeignKey Schema="Person" Table="StateProvince" Column="CountryRegionCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesTerritory" Column="TerritoryID"/>
			<ForeignKey Schema="Person" Table="StateProvince" Column="TerritoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="BillOfMaterials" Column="ProductAssemblyID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="BillOfMaterials" Column="ComponentID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="UnitMeasure" Column="UnitMeasureCode"/>
			<ForeignKey Schema="Production" Table="BillOfMaterials" Column="UnitMeasureCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductModel" Column="ProductModelID"/>
			<ForeignKey Schema="Production" Table="Product" Column="ProductModelID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductSubcategory" Column="ProductSubcategoryID"/>
			<ForeignKey Schema="Production" Table="Product" Column="ProductSubcategoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="UnitMeasure" Column="UnitMeasureCode"/>
			<ForeignKey Schema="Production" Table="Product" Column="SizeUnitMeasureCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="UnitMeasure" Column="UnitMeasureCode"/>
			<ForeignKey Schema="Production" Table="Product" Column="WeightUnitMeasureCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="ProductCostHistory" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Document" Column="DocumentID"/>
			<ForeignKey Schema="Production" Table="ProductDocument" Column="DocumentID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="ProductDocument" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Location" Column="LocationID"/>
			<ForeignKey Schema="Production" Table="ProductInventory" Column="LocationID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="ProductInventory" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="ProductListPriceHistory" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Illustration" Column="IllustrationID"/>
			<ForeignKey Schema="Production" Table="ProductModelIllustration" Column="IllustrationID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductModel" Column="ProductModelID"/>
			<ForeignKey Schema="Production" Table="ProductModelIllustration" Column="ProductModelID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Culture" Column="CultureID"/>
			<ForeignKey Schema="Production" Table="ProductModelProductDescriptionCulture" Column="CultureID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductDescription" Column="ProductDescriptionID"/>
			<ForeignKey Schema="Production" Table="ProductModelProductDescriptionCulture" Column="ProductDescriptionID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductModel" Column="ProductModelID"/>
			<ForeignKey Schema="Production" Table="ProductModelProductDescriptionCulture" Column="ProductModelID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="ProductProductPhoto" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductPhoto" Column="ProductPhotoID"/>
			<ForeignKey Schema="Production" Table="ProductProductPhoto" Column="ProductPhotoID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="ProductReview" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ProductCategory" Column="ProductCategoryID"/>
			<ForeignKey Schema="Production" Table="ProductSubcategory" Column="ProductCategoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="TransactionHistory" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Production" Table="WorkOrder" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="ScrapReason" Column="ScrapReasonID"/>
			<ForeignKey Schema="Production" Table="WorkOrder" Column="ScrapReasonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Location" Column="LocationID"/>
			<ForeignKey Schema="Production" Table="WorkOrderRouting" Column="LocationID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="WorkOrder" Column="WorkOrderID"/>
			<ForeignKey Schema="Production" Table="WorkOrderRouting" Column="WorkOrderID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Purchasing" Table="ProductVendor" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="UnitMeasure" Column="UnitMeasureCode"/>
			<ForeignKey Schema="Purchasing" Table="ProductVendor" Column="UnitMeasureCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="Vendor" Column="VendorID"/>
			<ForeignKey Schema="Purchasing" Table="ProductVendor" Column="VendorID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Purchasing" Table="PurchaseOrderDetail" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="PurchaseOrderHeader" Column="PurchaseOrderID"/>
			<ForeignKey Schema="Purchasing" Table="PurchaseOrderDetail" Column="PurchaseOrderID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="Purchasing" Table="PurchaseOrderHeader" Column="EmployeeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="ShipMethod" Column="ShipMethodID"/>
			<ForeignKey Schema="Purchasing" Table="PurchaseOrderHeader" Column="ShipMethodID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="Vendor" Column="VendorID"/>
			<ForeignKey Schema="Purchasing" Table="PurchaseOrderHeader" Column="VendorID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Address" Column="AddressID"/>
			<ForeignKey Schema="Purchasing" Table="VendorAddress" Column="AddressID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="AddressType" Column="AddressTypeID"/>
			<ForeignKey Schema="Purchasing" Table="VendorAddress" Column="AddressTypeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="Vendor" Column="VendorID"/>
			<ForeignKey Schema="Purchasing" Table="VendorAddress" Column="VendorID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Contact" Column="ContactID"/>
			<ForeignKey Schema="Purchasing" Table="VendorContact" Column="ContactID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="ContactType" Column="ContactTypeID"/>
			<ForeignKey Schema="Purchasing" Table="VendorContact" Column="ContactTypeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="Vendor" Column="VendorID"/>
			<ForeignKey Schema="Purchasing" Table="VendorContact" Column="VendorID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Contact" Column="ContactID"/>
			<ForeignKey Schema="Sales" Table="ContactCreditCard" Column="ContactID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="CreditCard" Column="CreditCardID"/>
			<ForeignKey Schema="Sales" Table="ContactCreditCard" Column="CreditCardID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="CountryRegion" Column="CountryRegionCode"/>
			<ForeignKey Schema="Sales" Table="CountryRegionCurrency" Column="CountryRegionCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Currency" Column="CurrencyCode"/>
			<ForeignKey Schema="Sales" Table="CountryRegionCurrency" Column="CurrencyCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Currency" Column="CurrencyCode"/>
			<ForeignKey Schema="Sales" Table="CurrencyRate" Column="FromCurrencyCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Currency" Column="CurrencyCode"/>
			<ForeignKey Schema="Sales" Table="CurrencyRate" Column="ToCurrencyCode"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesTerritory" Column="TerritoryID"/>
			<ForeignKey Schema="Sales" Table="Customer" Column="TerritoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Address" Column="AddressID"/>
			<ForeignKey Schema="Sales" Table="CustomerAddress" Column="AddressID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="AddressType" Column="AddressTypeID"/>
			<ForeignKey Schema="Sales" Table="CustomerAddress" Column="AddressTypeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Customer" Column="CustomerID"/>
			<ForeignKey Schema="Sales" Table="CustomerAddress" Column="CustomerID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Contact" Column="ContactID"/>
			<ForeignKey Schema="Sales" Table="Individual" Column="ContactID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Customer" Column="CustomerID"/>
			<ForeignKey Schema="Sales" Table="Individual" Column="CustomerID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesOrderHeader" Column="SalesOrderID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderDetail" Column="SalesOrderID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SpecialOfferProduct" Column="SpecialOfferID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderDetail" Column="SpecialOfferID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SpecialOfferProduct" Column="ProductID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderDetail" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Address" Column="AddressID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="BillToAddressID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Address" Column="AddressID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="ShipToAddressID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Contact" Column="ContactID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="ContactID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Purchasing" Table="ShipMethod" Column="ShipMethodID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="ShipMethodID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="CreditCard" Column="CreditCardID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="CreditCardID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="CurrencyRate" Column="CurrencyRateID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="CurrencyRateID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Customer" Column="CustomerID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="CustomerID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesPerson" Column="SalesPersonID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="SalesPersonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesTerritory" Column="TerritoryID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeader" Column="TerritoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesOrderHeader" Column="SalesOrderID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeaderSalesReason" Column="SalesOrderID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesReason" Column="SalesReasonID"/>
			<ForeignKey Schema="Sales" Table="SalesOrderHeaderSalesReason" Column="SalesReasonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="HumanResources" Table="Employee" Column="EmployeeID"/>
			<ForeignKey Schema="Sales" Table="SalesPerson" Column="SalesPersonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesTerritory" Column="TerritoryID"/>
			<ForeignKey Schema="Sales" Table="SalesPerson" Column="TerritoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesPerson" Column="SalesPersonID"/>
			<ForeignKey Schema="Sales" Table="SalesPersonQuotaHistory" Column="SalesPersonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="StateProvince" Column="StateProvinceID"/>
			<ForeignKey Schema="Sales" Table="SalesTaxRate" Column="StateProvinceID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesPerson" Column="SalesPersonID"/>
			<ForeignKey Schema="Sales" Table="SalesTerritoryHistory" Column="SalesPersonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesTerritory" Column="TerritoryID"/>
			<ForeignKey Schema="Sales" Table="SalesTerritoryHistory" Column="TerritoryID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Sales" Table="ShoppingCartItem" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Production" Table="Product" Column="ProductID"/>
			<ForeignKey Schema="Sales" Table="SpecialOfferProduct" Column="ProductID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SpecialOffer" Column="SpecialOfferID"/>
			<ForeignKey Schema="Sales" Table="SpecialOfferProduct" Column="SpecialOfferID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Customer" Column="CustomerID"/>
			<ForeignKey Schema="Sales" Table="Store" Column="CustomerID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="SalesPerson" Column="SalesPersonID"/>
			<ForeignKey Schema="Sales" Table="Store" Column="SalesPersonID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="Contact" Column="ContactID"/>
			<ForeignKey Schema="Sales" Table="StoreContact" Column="ContactID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Person" Table="ContactType" Column="ContactTypeID"/>
			<ForeignKey Schema="Sales" Table="StoreContact" Column="ContactTypeID"/>
		</Relation>
		<Relation>
			<PrimaryKey Schema="Sales" Table="Store" Column="CustomerID"/>
			<ForeignKey Schema="Sales" Table="StoreContact" Column="CustomerID"/>
		</Relation>
	</Relations>
</DatabaseSchema>
